**Purpose : This dofile cleans IDs for the teacher survey and other performs other corrections as far as data analysis is concerned per each varaibale
* Date created : 20 March 2019


clear all
set more off


cd "[directory]"	
	
	*SECTION 1. TEACHER AND SCHOOL IDENTIFICATION
	*********************************************
	
*Loading in the baseline dataset for IDs
use "Teacher_Survey_cleaned_baseline.dta", clear
gen myid = "1"
tostring school_code_107, replace
gen uniqueid = school_code_107 + "" +myid
order uniqueid, after(school_code_107)
keep school_name_106 school_code_107 uniqueid first_name_109 family_name_109
rename * bl_*
rename bl_uniqueid uniqueid
save "uniqueid_baseline.dta", replace

clear

*loading the endline teacher dataset
use "03 Endline_Teacher_Survey_Final.dta", clear

**/correcting the teacherid that was mistakenly created and entered at endline 
replace teacherid = 4011261 if key == "uuid:ea28017d-2346-4a32-84b1-3ae1cd37d2db"
replace reenter_teacherid = 4011261 if key == "uuid:ea28017d-2346-4a32-84b1-3ae1cd37d2db"


replace teacherid = 3011352 if key == "uuid:22a21be0-9b8f-4fac-a576-00339337787b"
replace reenter_teacherid = 3011352 if key == "uuid:22a21be0-9b8f-4fac-a576-00339337787b"

//The teacher named  was the one interviewed at baseline but was 
//and given a baseline ID but at endline a mistake was made where he was given a
//second ID while he was supposed to take the baseline ID assigned to his colleague
replace teacherid = 3041031 if key == "uuid:f2b085a2-8add-4238-9e36-012abeacef81"
replace reenter_teacherid = 3041031 if key == "uuid:f2b085a2-8add-4238-9e36-012abeacef81"

replace teacherid = 3041032 if key == "uuid:1c864d1a-044b-41ff-aa65-8240408365d2"
replace reenter_teacherid = 3041032 if key == "uuid:1c864d1a-044b-41ff-aa65-8240408365d2"


replace teacherid = 3051352 if key == "uuid:7cf4b4f2-19b2-4bae-b462-173000f23319"
replace reenter_teacherid = 3051352 if key == "uuid:7cf4b4f2-19b2-4bae-b462-173000f23319"

replace teacherid = 3051353 if key == "uuid:21ebba5c-0893-4862-9ac1-7e2c8415555a"
replace reenter_teacherid = 3051353 if key == "uuid:21ebba5c-0893-4862-9ac1-7e2c8415555a"


replace teacherid = 5060322 if key == "uuid:6a086b0c-c85d-4a7b-9350-2cb3bc9364c0"
replace reenter_teacherid = 5060322 if key == "uuid:6a086b0c-c85d-4a7b-9350-2cb3bc9364c0"

replace teacherid = 5060323 if key == "uuid:bfdf398b-67df-46cf-8705-3dd0db6d8d83"
replace reenter_teacherid = 5060323 if key == "uuid:bfdf398b-67df-46cf-8705-3dd0db6d8d83"


replace teacherid = 4021112 if key == "uuid:7f94f9b9-07e0-4301-87b7-292a4e1556bd"
replace reenter_teacherid = 4021112 if key == "uuid:7f94f9b9-07e0-4301-87b7-292a4e1556bd"


replace teacherid = 4021113 if key == "uuid:92017b00-9b31-46e9-b94f-8015569594bd"
replace reenter_teacherid = 4021113 if key == "uuid:92017b00-9b31-46e9-b94f-8015569594bd"
replace school_name_106 = 90 if teacherid == 4021161
replace school_name_106 = 128 if teacherid == 4030312


replace teacherid = 4030502 if key == "uuid:5e170511-b44b-4ad3-b4d7-84abce6ef078"
replace reenter_teacherid = 4030502 if key == "uuid:5e170511-b44b-4ad3-b4d7-84abce6ef078"



replace teacherid = 4051022 if key == "uuid:f2619dcd-24b1-4c00-b975-e82d9d15a3be"
replace reenter_teacherid = 4051022 if key == "uuid:f2619dcd-24b1-4c00-b975-e82d9d15a3be"



replace teacherid = 4051021 if key == "uuid:a14ae19d-7d26-4469-976f-ab584363a1de"
replace reenter_teacherid = 4051021 if key == "uuid:a14ae19d-7d26-4469-976f-ab584363a1de"



replace teacherid = 4051052 if key == "uuid:abc18c8e-5a4c-4f72-b702-5329a1168faa"
replace reenter_teacherid = 4051052 if key == "uuid:abc18c8e-5a4c-4f72-b702-5329a1168faa"


replace teacherid = 4051112 if key == "uuid:c47af4d3-e392-4f5e-a1e9-cd0fe08a8b01"
replace reenter_teacherid = 4051112 if key == "uuid:c47af4d3-e392-4f5e-a1e9-cd0fe08a8b01"


replace teacherid = 4051152 if key == "uuid:0df6e0e5-fddd-4053-8b9b-5922b08a647f"
replace reenter_teacherid = 4051152 if key == "uuid:0df6e0e5-fddd-4053-8b9b-5922b08a647f"


replace teacherid = 4051192 if key == "uuid:d57a917b-5281-45bc-a27e-315727eb7211"
replace reenter_teacherid = 4051192 if key == "uuid:d57a917b-5281-45bc-a27e-315727eb7211"


replace teacherid = 405191341 if key == "uuid:9d5d9c0f-41bb-4049-be05-ed760b195fe0"
replace reenter_teacherid = 405191341 if key == "uuid:9d5d9c0f-41bb-4049-be05-ed760b195fe0"


replace teacherid = 5030302 if key == "uuid:5e599299-2ac6-4558-bed5-609078df293d"
replace reenter_teacherid = 5030302 if key == "uuid:5e599299-2ac6-4558-bed5-609078df293d"

replace teacherid = 5030303 if key == "uuid:3a64423a-36b8-4eb4-98b1-dc41e2fc6ff0"
replace reenter_teacherid = 5030303 if key == "uuid:3a64423a-36b8-4eb4-98b1-dc41e2fc6ff0"


replace teacherid = 5030562 if key == "uuid:0c719191-3786-4ca2-ab0c-a2ad5d700a2e"
replace reenter_teacherid = 5030562 if key == "uuid:0c719191-3786-4ca2-ab0c-a2ad5d700a2e"

replace teacherid = 5030563 if key == "uuid:27851504-02eb-420e-b33f-8b2e4df94fdf"
replace reenter_teacherid = 5030563 if key == "uuid:27851504-02eb-420e-b33f-8b2e4df94fdf"


replace teacherid = 5031182 if key == "uuid:f00bcc21-127e-4566-974a-fe06de5168e0"
replace reenter_teacherid = 5031182 if key == "uuid:f00bcc21-127e-4566-974a-fe06de5168e0"


replace teacherid = 5040302 if key == "uuid:367a5991-bfc3-4c02-aeed-3c7207051843"



replace teacherid = 5061181 if key == "uuid:b12bbc2f-7811-4a6e-affe-5ea51b953a38"
replace reenter_teacherid = 5061181 if key == "uuid:b12bbc2f-7811-4a6e-affe-5ea51b953a38"

replace teacherid = 5061182 if key == "uuid:fe65516e-9581-4aff-8636-b3cd02ae1562"
replace reenter_teacherid = 5061182 if key == "uuid:fe65516e-9581-4aff-8636-b3cd02ae1562"


tostring teacherid, replace
gen uniqueid = teacherid
*bysort school_name_106: gen myid=_n
*tostring myid, replace

*tostring reenter_schoolid, replace
*gen uniqueid = reenter_schoolid + "" +myid
save "uniqueid_endline.dta", replace


// adding some info from baseline to the endline data set
clear

use "uniqueid_baseline.dta" //the file contains endline information

merge 1:m uniqueid using "uniqueid_endline.dta"
*order first_name_109 family_name_110, before(deviceid)

**checking if baseline names matches endline ones
gen name_check = "1" if bl_first_name_109 != first_name_109
gen school_check = "1" if bl_school_code_107 != schoolid
order name_check, before(deviceid)
order school_check, before(deviceid)

sort uniqueid
*order teacherid, after(uniqueid)
destring teacherid, replace
*drop if _merge == 1
*order school_name_106, before(uniqueid)
*order key, before(name_check)

drop schoolid_bas bl_school_name_106 bl_school_code_107 school_check bl_first_name_109 bl_family_name_109 name_check

destring schoolid, replace
drop if _merge == 1
drop _merge


*SECTION  2. TEACHER EXPERIENCE AND TEACHING
********************************************

//Correcting options
merge 1:1 uniqueid using "opt_correct.dta" //this file contains correct options

*208
*order values opt_118_meg opt_118_mce opt_118_heg opt_118_hel opt_118_lfk opt_118_lkk opt_118_lkf opt_118_bcg opt_118_hgl opt_118_leg opt_118_rhl opt_118_rhg opt_118_mpg opt_118_pcb opt_118_pcm opt_118_efk opt_118_mpb, before(stream_stream_208_1)
order values opt_118_pcm opt_118_pcb opt_118_mcb opt_118_mpg opt_118_mpc opt_118_meg opt_118_mce opt_118_heg opt_118_hel opt_118_lfk opt_118_lkk opt_118_lkf opt_118_bcg opt_118_hgl opt_118_leg opt_118_rhl opt_118_rhg opt_118_efk opt_118_mpb, before(stream_stream_208_1)

lab def yesnolbl 1 Yes 0 No
foreach var in opt_118_pcm opt_118_pcb opt_118_mcb opt_118_mpg opt_118_mpc opt_118_meg opt_118_mce opt_118_heg opt_118_hel opt_118_lfk opt_118_lkk opt_118_lkf opt_118_bcg opt_118_hgl opt_118_leg opt_118_rhl opt_118_rhg opt_118_efk opt_118_mpb{
lab var `var' "Which option?"
lab val `var' yesnolbl 

}

rename (opt_118_pcm opt_118_pcb opt_118_mcb opt_118_mpg opt_118_mpc opt_118_meg opt_118_mce opt_118_heg opt_118_hel opt_118_lfk opt_118_lkk opt_118_lkf opt_118_bcg opt_118_hgl opt_118_leg opt_118_rhl opt_118_rhg opt_118_efk opt_118_mpb) (opt_118_PCM opt_118_PCB opt_118_MCB_e opt_118_MPG opt_118_MPC opt_118_MEG opt_118_MCE opt_118_HEG opt_118_HEL opt_118_LFK opt_118_LKK opt_118_LKF opt_118_BCG opt_118_HGL opt_118_LEG opt_118_RHL opt_118_RHG opt_118_EFK_e opt_118_MPB_e)

//Correcting streams
gen stream_118 = values
replace stream_118 = "A" if stream_118 != ""
gen stream_118_A = "1" if stream_118 != ""
destring stream_118_A, replace
la de stream_118_A 1 "Yes" 0 "No"
la val stream_118_A stream_118_A

gen stream_118_B = "0" if stream_118 != ""
destring stream_118_B, replace
la de stream_118_B 1 "Yes" 0 "No"
la val stream_118_B stream_118_B

gen stream_118_C = "0" if stream_118 != ""
destring stream_118_C, replace
la de stream_118_C 1 "Yes" 0 "No"
la val stream_118_C stream_118_C

order stream_118 stream_118_A stream_118_B stream_118_C, before(values)

rename values opt_118

*208
//dropped below varaibales as they were recoredd in student_number_203/male_number_203/female_student_203
drop stream_stream_208_1 stream_male_208_1 stream_female_208_1 stream_stream_208_2
drop stream_male_208_2 stream_female_208_2 stream_stream_208_3 stream_male_208_3
drop stream_female_208_3 stream_stream_208_4 stream_male_208_4 stream_female_208_4
drop stream_stream_208_5 stream_male_208_5 stream_female_208_5 stream_stream_208_6
drop stream_male_208_6 stream_female_208_6


*SECTION 4. CURRICULAR KNOWLEDGE AND PERCEPTIONS
************************************************
*413 
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "3010362"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5030552"
replace appl_skillab_stu_413_spec_oth = "School competitions, making products of good quality" if uniqueid == "5031052"
replace appl_skillab_stu_413_spec_oth = "Exhibition of their products" if uniqueid == "5031141"
replace appl_skillab_stu_413_spec_oth = "Business club exhibitions shows through theaters and dance" if uniqueid == "5031211"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5040101"
replace appl_skillab_stu_413_spec_oth = "Exhibition of their products" if uniqueid == "5040103"
replace appl_skillab_stu_413_spec_oth = "Exhibition of their products" if uniqueid == "5040151"
replace appl_skillab_stu_413_spec_oth = "Networking with other entrepreneurs" if uniqueid == "5041074"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5041124"
replace appl_skillab_stu_413_spec_oth = "Making products of good quality" if uniqueid == "5041243"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5061021"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5061022"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5061071"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5061072"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5061141"
replace appl_skillab_stu_413_spec_oth = "The school does not have a business club" if uniqueid == "5061142"
replace appl_skillab_stu_413_spec_oth = "Learning tours, talent show, interclass competition" if uniqueid == "5061173"

*414
replace incl_bus_plan_414_spec_other = "Business capital" if uniqueid == "3010133"
replace incl_bus_plan_414_spec_other = "Market analysis" if uniqueid == "3010333"
replace incl_bus_plan_414_spec_other = "Project objective" if uniqueid == "3010381"
replace incl_bus_plan_414_spec_other = "Market analysis, project objective" if uniqueid == "5031021"
replace incl_bus_plan_414_spec_other = "Budget, products/services, source of capital, profitability, capital, customers, project initiator profile" if uniqueid == "5031141"
replace incl_bus_plan_414_spec_other = "Breakdown of business activities" if uniqueid == "5031191"
replace incl_bus_plan_414_spec_other = "Interest to the public" if uniqueid == "5031212"
replace incl_bus_plan_414_spec_other = "Project overview, breakdown of activities, capital, products/services, number of employees and salary structure, organization plan" if uniqueid == "5040103"
replace incl_bus_plan_414_spec_other = "Market analysis" if uniqueid == "5040562"
replace incl_bus_plan_414_spec_other = "Innovation plan" if uniqueid == "50410212"
replace incl_bus_plan_414_spec_other = "Literature review, Employees" if uniqueid == "5060323"
replace incl_bus_plan_414_spec_other = "Materials need" if uniqueid == "5060331"
replace incl_bus_plan_414_spec_other = "Capital and business location" if uniqueid == "5061141"
replace incl_bus_plan_414_spec_other = "Location, source of capital, customers, project objective, interest to the public" if uniqueid == "5061142"
replace incl_bus_plan_414_spec_other = "Project objective" if uniqueid == "5061152"
drop _merge

//cleaning units
merge 1:1 uniqueid using "units_corr.dta" //the file contains the cleaned units as of endline

order unit unit_class, after(much_covered_403)

la var unit "Unit in S4/S5/S6"
la de unit 1 "Unit 1" 2 "Unit 2" 3 "Unit 3" 4 "Unit 4" 5 "Unit 5" 6 "Unit 6" 7 "Unit 7" 8 "Unit 8" 9 "Unit 9" 10 "Unit 10" 11 "Unit 11" 12 "Unit 12" 13 "Unit 13" -55 "N/A"
la val unit unit

replace unit_class = 1 if unit_class == 4
replace unit_class = 2 if unit_class == 5
replace unit_class = 3 if unit_class == 6

la var unit_class "Unit Class"
la de unit_class 1 "S4" 2 "S5" 3 "S6"
la val unit_class unit_class

drop much_covered_403 names
rename unit much_covered_403

la var much_covered_403 "403. Which unit of the S6 syllabus are you currently covering in class? Enter the unit he/she is at. If it's a S4 teacher, ask for S4 class."



*replace unit_s6 = . if class_level_112_6 == 0 // makes it relevant to S6 classes only
drop if _merge ==2
drop _merge



***************************
//Keeping consistent baseline vs endline variable names

*SECTION 1. Teacher and school identification
*^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

rename (enum_code enumename) (enumerator_id_113 enumerator_name_113) 
rename consent consent_e
rename baseline_112 baseline_112_e
rename age_200 age_201
rename qualification_201 qual_203
rename devide_class_204 devide_class_204_e
rename gender_111 gender_200
rename family_name_110 family_name_109
rename competencybased_209 traincurr_220
rename (fromwhom_210 fromwhom_210_1 fromwhom_210_2 fromwhom_210_3 fromwhom_210_4 numb_training_211 days_traning_212 fromwhom_213 fromwhom_213_1 fromwhom_213_2 fromwhom_213_3 fromwhom_213_4)(fromwhom_210_e fromwhom_210_1_e fromwhom_210_2_e fromwhom_210_3_e fromwhom_210_4_e numb_training_211_e days_traning_212_e fromwhom_213_e fromwhom_213_1_e fromwhom_213_2_e fromwhom_213_3_e fromwhom_213_4_e)
rename (rec_new_curr_401 reb_textbook_402)(rec_new_curr_401_e reb_textbook_402_e)

rename (class_level_112 class_level_112_1 class_level_112_2 class_level_112_3 class_level_112_4 class_level_112_5 class_level_112_6 class_level_112_7) (class_level_112_e class_level_112_1_e class_level_112_2_e class_level_112_3_e class_level_112_4_e class_level_112_5_e class_level_112_6_e class_level_112_7_e)


rename (male_number_203 female_student_203) (malestud_212 femalestud_212)
rename year_start_202 year_start_202_e
rename student_number_203 student_number_203_e

label variable stream_118_A "Which stream?"
label variable stream_118 "Which stream?"
label variable stream_118_B "Which stream?"
label variable stream_118_C "Which stream?"
label variable opt_118 "Which option?"
notes much_covered_403: 403. Which unit of the S6 syllabus are you currently covering in class? Enter the unit he/she is at. If it's a S4 teacher, ask for S4 class.



*SECTION 2. Teacher Experience and Training 
*^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
*204
destring uniqueid, replace
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 5071182
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 5071202
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 5040152
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 5041141
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 5061092
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 5060334
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4021062
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4020321
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4021101
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4051053
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4051111
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4051201
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4030573
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4031281
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4010301
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4010142
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 4011192
replace student_number_203_e = malestud_212+femalestud_212 if uniqueid == 3010151
tostring uniqueid, replace

*SECTION 4. Curricular Knowledge and Perceptions
*^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
*Question:414. What should be included in a student’s business plan? 
rename (much_covered_403 unit_class hours_entr_404) (much_covered_403_e unit_class_e hours_entr_404_e)
rename (observ_other_teach_405 observ_numb_405 observ_you_406 observ_you_numb_406)(obstrain_222_e nbrobstrain_222_e othobstrain_223_e nbrothobstrain_223_e)
rename lessonplan_407 writtentr_224
rename skillslab_408 skillslab_408_e
rename lessonnote_409 writtlesso_225
rename (skills_lab_def_free_411 skills_lab_def_411 skillslab_taught_412) (def_skilllab_315 skills_lab_def_411_e skillslab_taught_412_e)
rename (appl_skillslab_stu_413 appl_skillslab_stu_413_1 appl_skillslab_stu_413_2 appl_skillslab_stu_413_3 appl_skillslab_stu_413_4 appl_skillslab_stu_413_5 appl_skillslab_stu_413_6 appl_skillslab_stu_413_other appl_skillab_stu_413_spec_oth)(mrktskl_400 mrktskl_400_DevProBrand mrktskl_400_Advert mrktskl_400_KeepingAccount mrktskl_400_BusinessReg mrktskl_400_VerbalProm appl_skillslab_stu_413_6_e appl_skillslab_stu_413_other_e appl_skillab_stu_413_spec_oth_e)
rename (incl_bus_plan_414 incl_bus_plan_414_1 incl_bus_plan_414_2 incl_bus_plan_414_3 incl_bus_plan_414_4 incl_bus_plan_414_5 incl_bus_plan_414_other)(busplnskl_401 busplnskl_401_BusiName busplnskl_401_ReceiFromSales busplnskl_401_MarketgPlan busplnskl_401_PandLStatemt busplnskl_401_Audit busplnskl_401_Other_e)

rename  incl_bus_plan_414_spec_other busplnskl_401_Other_specify_e
drop incl_bus_plan_414_6 // dropped as it was not part of answer choices/options for this particluar question
rename (balenc_sheet_415 balenc_sheet_415_1 balenc_sheet_415_2 balenc_sheet_415_3 balenc_sheet_415_4 balenc_sheet_415_5 balenc_sheet_415_6 balenc_sheet_415_7) (balenc_sheet_415_e balenc_sheet_415_1_e balenc_sheet_415_2_e balenc_sheet_415_3_e balenc_sheet_415_4_e balenc_sheet_415_5_e balenc_sheet_415_6_e balenc_sheet_415_7_e)
rename (enjoy_teac_416 empr_my_skills_418 empr_learner_skills_419)(enjoy_teac_416_e empr_my_skills_418_e empr_learner_skills_419_e)
rename (entr_2015_420 new_vs_old_421 skills_uneder_new_422 lear_better_new_423 lern_pass_better_424)(entr_2015_420_e new_vs_old_421_e skills_uneder_new_422_e lear_better_new_423_e lern_pass_better_424_e)
//Most comfortable in
gen teach_method_425_12 = 0
la var teach_method_425_12 "What are the teaching methods or pedagogies that you are most comfortable using?"
la de teach_method_425_12 1 "Yes" 0 "No"
la val teach_method_425_12 teach_method_425_12
order teach_method_425_12, after(teach_method_425_11)

rename (teach_method_425 teach_method_425_1 teach_method_425_2 teach_method_425_3 teach_method_425_4 teach_method_425_5 teach_method_425_6 teach_method_425_7 teach_method_425_8 teach_method_425_9 teach_method_425_10 teach_method_425_11 teach_method_425_12)(meth_300 meth_300_mostcomf_Lect meth_300_mostcomf_QandA meth_300_mostcomf_Quiz meth_300_mostcomf_GroupWork meth_300_mostcomf_Games meth_300_mostcomf_Discussion meth_300_mostcomf_ActOutClass meth_300_mostcomf_ReadFromText meth_300_mostcomf_PracticeEx meth_300_mostcomf_Research meth_300_mostcomf_Experiment meth_300_mostcomf_Portfolio)


*Section  5. Teacher Income and Job Satisfaction 
*^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
rename (othoccup_500 hrsothoccup_501)(othoccup_600 hrsothoccup_601)

*Question: 502_How satisfied or dissatisfied are you with your teaching job from the following points of view?
rename (point1_502 point2_502 point3_502 point4_502 point5_502 point6_502 point7_502 point8_502 point9_502)(point1_606 point2_606 point3_606 point4_606 point5_606 point6_606 point7_606 point8_606 point9_606)

drop feedback //not relevant information

save "03 Endline_Teacher_Survey_Final_Clean.dta", replace

//Comparing both baseline and endline data sets
cfvars "Teacher_Survey_cleaned_baseline.dta" // compares the data in memory (teacher endline) with the baseline datset



